Home » RDBMS Server » Server Utilities » dbstart does not find correct db version
dbstart does not find correct db version [message #71488] Tue, 12 November 2002 05:57 Go to next message
Joerg
Messages: 2
Registered: November 2002
Junior Member
The dbstart script on Solaris (Oracle 8.1.6) tries to find the db version by grepping for the PL/SQL-Version output from the command "svrmgrl command=exit".

But this command does not show the PL/SQL-Version (though it is installed!)

It seems that the svrmgrl can't find PL/SQL?
Do I have to set a special variable?
Re: dbstart does not find correct db version [message #71490 is a reply to message #71488] Tue, 12 November 2002 08:32 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
change by :

if test -f $ORACLE_HOME/bin/svrmgrl; then
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/PL/SQL (Release&#124Version)/ {print substr($3,1,3) ; exit}
/Oracle7 Server (Release&#124Version)/ {print substr($4,1,4) ; exit}
/Oracle8i Enterprise Edition (Release&#124Version)/ {print substr($5,1,3); exit}
/Oracle8i (Release&#124Version)/ {print substr($3,1,3); exit}'`
else
VERSION="8.2"
fi
fi
Re: dbstart does not find correct db version [message #71494 is a reply to message #71488] Wed, 13 November 2002 16:47 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
It was a bug in the dbstart script for 8.1.6. To read more about it and how to fix it Click Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: Where is the Server-Manager (svrmgrm)
Next Topic: Migration
Goto Forum:
  


Current Time: Thu Oct 31 21:21:59 CDT 2024